package com.boat.io.statisticsTable;

import com.boat.io.util.FileUtil;

import java.util.List;

public class Exec {
    public static void main(String[] args) {
        String file = "E:\\gitee\\boat\\JavaIo\\src\\main\\java\\com\\boat\\io\\statisticsTable\\db_vehicle517.sql";
        List<String> list = FileUtil.readFileByLines(file);
        for (String s : list) {
            if(s.contains("CREATE TABLE ")){
                if(s.contains("_202")||s.contains("_2019")){
                    continue;
                }
                System.out.println(s.replace("CREATE TABLE `","").replace("` (",""));
            }
        }
    }
}
